<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head>
<title>misc/syntax/hive.syntax</title>
<meta name='robots' content='noindex,nofollow' />
<meta name='generator' content='GLOBAL-6.5.7' />
<meta http-equiv='Content-Style-Type' content='text/css' />
<link rel='stylesheet' type='text/css' href='../style.css' />
</head>
<body>
<!-- beginning of fixed guide -->
<div id='guide'><ul>
<li><a href='#TOP'><img class='icon' src='../icons/first.png' alt='[^]' /></a></li>
<li><a href='#BOTTOM'><img class='icon' src='../icons/last.png' alt='[v]' /></a></li>
<li><a href='#TOP'><img class='icon' src='../icons/top.png' alt='[top]' /></a></li>
<li><a href='#BOTTOM'><img class='icon' src='../icons/bottom.png' alt='[bottom]' /></a></li>
<li><a href='../mains.html'><img class='icon' src='../icons/index.png' alt='[index]' /></a></li>
<li><a href='../help.html'><img class='icon' src='../icons/help.png' alt='[help]' /></a></li>
<li class='standout'><span><a href='../files/misc.html'>misc</a>/<a href='../files/misc--syntax.html'>syntax</a>/hive.syntax</span></li>
</ul></div>
<!-- end of fixed guide -->
<a id='TOP' name='TOP'></a><h2 class='header'><a href='../mains.html'>root</a>/<a href='../files/misc.html'>misc</a>/<a href='../files/misc--syntax.html'>syntax</a>/hive.syntax</h2>
<em class='comment'>/* <img class='icon' src='../icons/n_left.png' alt='[previous]' /><img class='icon' src='../icons/n_right.png' alt='[next]' /><img class='icon' src='../icons/n_first.png' alt='[first]' /><img class='icon' src='../icons/n_last.png' alt='[last]' /><img class='icon' src='../icons/n_top.png' alt='[top]' /><a href='#BOTTOM'><img class='icon' src='../icons/bottom.png' alt='[bottom]' /></a><a href='../mains.html'><img class='icon' src='../icons/index.png' alt='[index]' /></a><a href='../help.html'><img class='icon' src='../icons/help.png' alt='[help]' /></a>&nbsp;<input type='text' readonly onfocus='this.select();' value='+1 misc/syntax/hive.syntax'  /> */</em>
<hr />
<pre>
<a id='L1' name='L1'></a># HQL syntax highlighting
<a id='L2' name='L2'></a># by Michal Lorek &lt;michal.lorek@gmail.com&gt;
<a id='L3' name='L3'></a> 
<a id='L4' name='L4'></a>caseinsensitive
<a id='L5' name='L5'></a> 
<a id='L6' name='L6'></a>context default
<a id='L7' name='L7'></a> 
<a id='L8' name='L8'></a># Keywords
<a id='L9' name='L9'></a>    keyword whole TRUE                                     white
<a id='L10' name='L10'></a>    keyword whole FALSE                                    white
<a id='L11' name='L11'></a>    keyword whole ALL                                      white
<a id='L12' name='L12'></a>    keyword whole NONE                                     white
<a id='L13' name='L13'></a>    keyword whole AND                                      white
<a id='L14' name='L14'></a>    keyword whole OR                                       white
<a id='L15' name='L15'></a>    keyword whole NOT                                      white
<a id='L16' name='L16'></a>    keyword whole !                                        brightcyan
<a id='L17' name='L17'></a>    keyword whole LIKE                                     white
<a id='L18' name='L18'></a>    keyword whole ANY                                      white
<a id='L19' name='L19'></a>    keyword whole IF                                       white
<a id='L20' name='L20'></a>    keyword whole EXISTS                                   white
<a id='L21' name='L21'></a>    keyword whole ASC                                      white
<a id='L22' name='L22'></a>    keyword whole DESC                                     white
<a id='L23' name='L23'></a>    keyword whole NULLS                                    white
<a id='L24' name='L24'></a>    keyword whole LAST                                     white
<a id='L25' name='L25'></a>    keyword whole ORDER                                    white
<a id='L26' name='L26'></a>    keyword whole GROUP                                    white
<a id='L27' name='L27'></a>    keyword whole BY                                       white
<a id='L28' name='L28'></a>    keyword whole HAVING                                   white
<a id='L29' name='L29'></a>    keyword whole WHERE                                    white
<a id='L30' name='L30'></a>    keyword whole FROM                                     white
<a id='L31' name='L31'></a>    keyword whole AS                                       white
<a id='L32' name='L32'></a>    keyword whole SELECT                                   white
<a id='L33' name='L33'></a>    keyword whole DISTINCT                                 white
<a id='L34' name='L34'></a>    keyword whole INSERT                                   white
<a id='L35' name='L35'></a>    keyword whole OVERWRITE                                magenta
<a id='L36' name='L36'></a>    keyword whole OUTER                                    white
<a id='L37' name='L37'></a>    keyword whole UNIQUEJOIN                               white
<a id='L38' name='L38'></a>    keyword whole PRESERVE                                 white
<a id='L39' name='L39'></a>    keyword whole JOIN                                     white
<a id='L40' name='L40'></a>    keyword whole LEFT                                     white
<a id='L41' name='L41'></a>    keyword whole RIGHT                                    white
<a id='L42' name='L42'></a>    keyword whole FULL                                     white
<a id='L43' name='L43'></a>    keyword whole ON                                       white
<a id='L44' name='L44'></a>    keyword whole PARTITION                                white
<a id='L45' name='L45'></a>    keyword whole PARTITIONS                               white
<a id='L46' name='L46'></a>    keyword whole TABLE                                    white
<a id='L47' name='L47'></a>    keyword whole TABLES                                   white
<a id='L48' name='L48'></a>    keyword whole COLUMNS                                  white
<a id='L49' name='L49'></a>    keyword whole INDEX                                    white
<a id='L50' name='L50'></a>    keyword whole INDEXES                                  white
<a id='L51' name='L51'></a>    keyword whole REBUILD                                  white
<a id='L52' name='L52'></a>    keyword whole FUNCTIONS                                white
<a id='L53' name='L53'></a>    keyword whole SHOW                                     white
<a id='L54' name='L54'></a>    keyword whole MSCK                                     white
<a id='L55' name='L55'></a>    keyword whole REPAIR                                   white
<a id='L56' name='L56'></a>    keyword whole DIRECTORY                                magenta
<a id='L57' name='L57'></a>    keyword whole LOCAL                                    magenta
<a id='L58' name='L58'></a>    keyword whole TRANSFORM                                white
<a id='L59' name='L59'></a>    keyword whole USING                                    white
<a id='L60' name='L60'></a>    keyword whole CLUSTER                                  white
<a id='L61' name='L61'></a>    keyword whole DISTRIBUTE                               white
<a id='L62' name='L62'></a>    keyword whole SORT                                     white
<a id='L63' name='L63'></a>    keyword whole UNION                                    white
<a id='L64' name='L64'></a>    keyword whole EXCEPT                                   white
<a id='L65' name='L65'></a>    keyword whole LOAD                                     white
<a id='L66' name='L66'></a>    keyword whole EXPORT                                   white
<a id='L67' name='L67'></a>    keyword whole IMPORT                                   white
<a id='L68' name='L68'></a>    keyword whole REPLICATION                              white
<a id='L69' name='L69'></a>    keyword whole METADATA                                 white
<a id='L70' name='L70'></a>    keyword whole DATA                                     white
<a id='L71' name='L71'></a>    keyword whole INPATH                                   white
<a id='L72' name='L72'></a>    keyword whole IS                                       white
<a id='L73' name='L73'></a>    keyword whole NULL                                     white
<a id='L74' name='L74'></a>    keyword whole CREATE                                   white
<a id='L75' name='L75'></a>    keyword whole EXTERNAL                                 white
<a id='L76' name='L76'></a>    keyword whole ALTER                                    white
<a id='L77' name='L77'></a>    keyword whole CHANGE                                   white
<a id='L78' name='L78'></a>    keyword whole COLUMN                                   white
<a id='L79' name='L79'></a>    keyword whole FIRST                                    white
<a id='L80' name='L80'></a>    keyword whole AFTER                                    white
<a id='L81' name='L81'></a>    keyword whole DESCRIBE                                 magenta
<a id='L82' name='L82'></a>    keyword whole DROP                                     white
<a id='L83' name='L83'></a>    keyword whole RENAME                                   white
<a id='L84' name='L84'></a>    keyword whole TO                                       white
<a id='L85' name='L85'></a>    keyword whole COMMENT                                  white
<a id='L86' name='L86'></a>    keyword whole BOOLEAN                                  white
<a id='L87' name='L87'></a>    keyword whole TINYINT                                  white
<a id='L88' name='L88'></a>    keyword whole SMALLINT                                 white
<a id='L89' name='L89'></a>    keyword whole INT                                      white
<a id='L90' name='L90'></a>    keyword whole INTEGER                                  white
<a id='L91' name='L91'></a>    keyword whole BIGINT                                   white
<a id='L92' name='L92'></a>    keyword whole FLOAT                                    white
<a id='L93' name='L93'></a>    keyword whole DOUBLE                                   white
<a id='L94' name='L94'></a>    keyword whole PRECISION                                white
<a id='L95' name='L95'></a>    keyword whole DATE                                     white
<a id='L96' name='L96'></a>    keyword whole DATETIME                                 white
<a id='L97' name='L97'></a>    keyword whole TIMESTAMP                                white
<a id='L98' name='L98'></a>    keyword whole TIMESTAMPTZ                              white
<a id='L99' name='L99'></a>    keyword whole TIME                                     white
<a id='L100' name='L100'></a>    keyword whole ZONE                                     white
<a id='L101' name='L101'></a>    keyword whole INTERVAL                                 white
<a id='L102' name='L102'></a>    keyword whole DECIMAL                                  white
<a id='L103' name='L103'></a>    keyword whole DEC                                      white
<a id='L104' name='L104'></a>    keyword whole NUMERIC                                  white
<a id='L105' name='L105'></a>    keyword whole STRING                                   white
<a id='L106' name='L106'></a>    keyword whole CHAR                                     white
<a id='L107' name='L107'></a>    keyword whole VARCHAR                                  white
<a id='L108' name='L108'></a>    keyword whole ARRAY                                    white
<a id='L109' name='L109'></a>    keyword whole STRUCT                                   white
<a id='L110' name='L110'></a>    keyword whole MAP                                      white
<a id='L111' name='L111'></a>    keyword whole UNIONTYPE                                white
<a id='L112' name='L112'></a>    keyword whole REDUCE                                   white
<a id='L113' name='L113'></a>    keyword whole PARTITIONED                              white
<a id='L114' name='L114'></a>    keyword whole CLUSTERED                                white
<a id='L115' name='L115'></a>    keyword whole SORTED                                   white
<a id='L116' name='L116'></a>    keyword whole INTO                                     white
<a id='L117' name='L117'></a>    keyword whole BUCKETS                                  white
<a id='L118' name='L118'></a>    keyword whole ROW                                      magenta
<a id='L119' name='L119'></a>    keyword whole ROWS                                     magenta
<a id='L120' name='L120'></a>    keyword whole FORMAT                                   magenta
<a id='L121' name='L121'></a>    keyword whole DELIMITED                                magenta
<a id='L122' name='L122'></a>    keyword whole FIELDS                                   magenta
<a id='L123' name='L123'></a>    keyword whole TERMINATED                               magenta
<a id='L124' name='L124'></a>    keyword whole ESCAPED                                  magenta
<a id='L125' name='L125'></a>    keyword whole COLLECTION                               white
<a id='L126' name='L126'></a>    keyword whole ITEMS                                    white
<a id='L127' name='L127'></a>    keyword whole KEYS                                     white
<a id='L128' name='L128'></a>    keyword whole $KEY$                                    white
<a id='L129' name='L129'></a>    keyword whole LINES                                    magenta
<a id='L130' name='L130'></a>    keyword whole STORED                                   magenta
<a id='L131' name='L131'></a>    keyword whole FILEFORMAT                               magenta
<a id='L132' name='L132'></a>    keyword whole INPUTFORMAT                              magenta
<a id='L133' name='L133'></a>    keyword whole OUTPUTFORMAT                             magenta
<a id='L134' name='L134'></a>    keyword whole INPUTDRIVER                              white
<a id='L135' name='L135'></a>    keyword whole OUTPUTDRIVER                             white
<a id='L136' name='L136'></a>    keyword whole ENABLE                                   white
<a id='L137' name='L137'></a>    keyword whole DISABLE                                  white
<a id='L138' name='L138'></a>    keyword whole LOCATION                                 magenta
<a id='L139' name='L139'></a>    keyword whole TABLESAMPLE                              white
<a id='L140' name='L140'></a>    keyword whole BUCKET                                   white
<a id='L141' name='L141'></a>    keyword whole OUT                                      white
<a id='L142' name='L142'></a>    keyword whole OF                                       white
<a id='L143' name='L143'></a>    keyword whole PERCENT                                  white
<a id='L144' name='L144'></a>    keyword whole CAST                                     cyan
<a id='L145' name='L145'></a>    keyword whole ADD                                      white
<a id='L146' name='L146'></a>    keyword whole REPLACE                                  white
<a id='L147' name='L147'></a>    keyword whole RLIKE                                    white
<a id='L148' name='L148'></a>    keyword whole REGEXP                                   white
<a id='L149' name='L149'></a>    keyword whole TEMPORARY                                white
<a id='L150' name='L150'></a>    keyword whole FUNCTION                                 white
<a id='L151' name='L151'></a>    keyword whole MACRO                                    white
<a id='L152' name='L152'></a>    keyword whole FILE                                     white
<a id='L153' name='L153'></a>    keyword whole JAR                                      white
<a id='L154' name='L154'></a>    keyword whole EXPLAIN                                  white
<a id='L155' name='L155'></a>    keyword whole EXTENDED                                 white
<a id='L156' name='L156'></a>    keyword whole FORMATTED                                white
<a id='L157' name='L157'></a>    keyword whole PRETTY                                   white
<a id='L158' name='L158'></a>    keyword whole DEPENDENCY                               white
<a id='L159' name='L159'></a>    keyword whole LOGICAL                                  white
<a id='L160' name='L160'></a>    keyword whole SERDE                                    white
<a id='L161' name='L161'></a>    keyword whole WITH                                     white
<a id='L162' name='L162'></a>    keyword whole DEFERRED                                 white
<a id='L163' name='L163'></a>    keyword whole SERDEPROPERTIES                          white
<a id='L164' name='L164'></a>    keyword whole DBPROPERTIES                             white
<a id='L165' name='L165'></a>    keyword whole LIMIT                                    white
<a id='L166' name='L166'></a>    keyword whole OFFSET                                   white
<a id='L167' name='L167'></a>    keyword whole SET                                      white
<a id='L168' name='L168'></a>    keyword whole UNSET                                    white
<a id='L169' name='L169'></a>    keyword whole TBLPROPERTIES                            white
<a id='L170' name='L170'></a>    keyword whole IDXPROPERTIES                            white
<a id='L171' name='L171'></a>    keyword whole $VALUE$                                  white
<a id='L172' name='L172'></a>    keyword whole $ELEM$                                   white
<a id='L173' name='L173'></a>    keyword whole DEFINED                                  white
<a id='L174' name='L174'></a>    keyword whole CASE                                     white
<a id='L175' name='L175'></a>    keyword whole WHEN                                     white
<a id='L176' name='L176'></a>    keyword whole THEN                                     white
<a id='L177' name='L177'></a>    keyword whole ELSE                                     white
<a id='L178' name='L178'></a>    keyword whole END                                      white
<a id='L179' name='L179'></a>    keyword whole MAPJOIN                                  white
<a id='L180' name='L180'></a>    keyword whole STREAMTABLE                              white
<a id='L181' name='L181'></a>    keyword whole CLUSTERSTATUS                            white
<a id='L182' name='L182'></a>    keyword whole UTC                                      white
<a id='L183' name='L183'></a>    keyword whole UTC_TMESTAMP                             white
<a id='L184' name='L184'></a>    keyword whole LONG                                     white
<a id='L185' name='L185'></a>    keyword whole DELETE                                   white
<a id='L186' name='L186'></a>    keyword whole PLUS                                     white
<a id='L187' name='L187'></a>    keyword whole MINUS                                    white
<a id='L188' name='L188'></a>    keyword whole FETCH                                    white
<a id='L189' name='L189'></a>    keyword whole INTERSECT                                white
<a id='L190' name='L190'></a>    keyword whole VIEW                                     white
<a id='L191' name='L191'></a>    keyword whole VIEWS                                    white
<a id='L192' name='L192'></a>    keyword whole IN                                       white
<a id='L193' name='L193'></a>    keyword whole DATABASE                                 white
<a id='L194' name='L194'></a>    keyword whole DATABASES                                white
<a id='L195' name='L195'></a>    keyword whole MATERIALIZED                             white
<a id='L196' name='L196'></a>    keyword whole SCHEMA                                   white
<a id='L197' name='L197'></a>    keyword whole SCHEMAS                                  white
<a id='L198' name='L198'></a>    keyword whole GRANT                                    white
<a id='L199' name='L199'></a>    keyword whole REVOKE                                   white
<a id='L200' name='L200'></a>    keyword whole SSL                                      white
<a id='L201' name='L201'></a>    keyword whole UNDO                                     white
<a id='L202' name='L202'></a>    keyword whole LOCK                                     white
<a id='L203' name='L203'></a>    keyword whole LOCKS                                    white
<a id='L204' name='L204'></a>    keyword whole UNLOCK                                   white
<a id='L205' name='L205'></a>    keyword whole SHARED                                   white
<a id='L206' name='L206'></a>    keyword whole EXCLUSIVE                                white
<a id='L207' name='L207'></a>    keyword whole PROCEDURE                                white
<a id='L208' name='L208'></a>    keyword whole UNSIGNED                                 white
<a id='L209' name='L209'></a>    keyword whole WHILE                                    white
<a id='L210' name='L210'></a>    keyword whole READ                                     white
<a id='L211' name='L211'></a>    keyword whole READS                                    white
<a id='L212' name='L212'></a>    keyword whole PURGE                                    white
<a id='L213' name='L213'></a>    keyword whole RANGE                                    white
<a id='L214' name='L214'></a>    keyword whole ANALYZE                                  white
<a id='L215' name='L215'></a>    keyword whole BEFORE                                   white
<a id='L216' name='L216'></a>    keyword whole BETWEEN                                  white
<a id='L217' name='L217'></a>    keyword whole BOTH                                     white
<a id='L218' name='L218'></a>    keyword whole BINARY                                   white
<a id='L219' name='L219'></a>    keyword whole CROSS                                    white
<a id='L220' name='L220'></a>    keyword whole CONTINUE                                 white
<a id='L221' name='L221'></a>    keyword whole CURSOR                                   white
<a id='L222' name='L222'></a>    keyword whole TRIGGER                                  white
<a id='L223' name='L223'></a>    keyword whole RECORDREADER                             white
<a id='L224' name='L224'></a>    keyword whole RECORDWRITER                             white
<a id='L225' name='L225'></a>    keyword whole SEMI                                     white
<a id='L226' name='L226'></a>    keyword whole LATERAL                                  magenta
<a id='L227' name='L227'></a>    keyword whole TOUCH                                    white
<a id='L228' name='L228'></a>    keyword whole ARCHIVE                                  magenta
<a id='L229' name='L229'></a>    keyword whole UNARCHIVE                                magenta
<a id='L230' name='L230'></a>    keyword whole COMPUTE                                  white
<a id='L231' name='L231'></a>    keyword whole STATISTICS                               white
<a id='L232' name='L232'></a>    keyword whole USE                                      magenta
<a id='L233' name='L233'></a>    keyword whole OPTION                                   white
<a id='L234' name='L234'></a>    keyword whole CONCATENATE                              magenta
<a id='L235' name='L235'></a>    keyword whole SHOW_DATABASE                            white
<a id='L236' name='L236'></a>    keyword whole UPDATE                                   white
<a id='L237' name='L237'></a>    keyword whole RESTRICT                                 white
<a id='L238' name='L238'></a>    keyword whole CASCADE                                  white
<a id='L239' name='L239'></a>    keyword whole SKEWED                                   white
<a id='L240' name='L240'></a>    keyword whole ROLLUP                                   white
<a id='L241' name='L241'></a>    keyword whole CUBE                                     white
<a id='L242' name='L242'></a>    keyword whole DIRECTORIES                              white
<a id='L243' name='L243'></a>    keyword whole FOR                                      white
<a id='L244' name='L244'></a>    keyword whole WINDOW                                   white
<a id='L245' name='L245'></a>    keyword whole UNBOUNDED                                white
<a id='L246' name='L246'></a>    keyword whole PRECEDING                                white
<a id='L247' name='L247'></a>    keyword whole FOLLOWING                                white
<a id='L248' name='L248'></a>    keyword whole CURRENT                                  white
<a id='L249' name='L249'></a>    keyword whole CURRENT_DATE                             white
<a id='L250' name='L250'></a>    keyword whole CURRENT_TIMESTAMP                        white
<a id='L251' name='L251'></a>    keyword whole LESS                                     white
<a id='L252' name='L252'></a>    keyword whole MORE                                     white
<a id='L253' name='L253'></a>    keyword whole OVER                                     white
<a id='L254' name='L254'></a>    keyword whole GROUPING                                 white
<a id='L255' name='L255'></a>    keyword whole SETS                                     white
<a id='L256' name='L256'></a>    keyword whole TRUNCATE                                 white
<a id='L257' name='L257'></a>    keyword whole NOSCAN                                   white
<a id='L258' name='L258'></a>    keyword whole PARTIALSCAN                              white
<a id='L259' name='L259'></a>    keyword whole USER                                     white
<a id='L260' name='L260'></a>    keyword whole ROLE                                     white
<a id='L261' name='L261'></a>    keyword whole ROLES                                    white
<a id='L262' name='L262'></a>    keyword whole INNER                                    white
<a id='L263' name='L263'></a>    keyword whole EXCHANGE                                 white
<a id='L264' name='L264'></a>    keyword whole URI                                      white
<a id='L265' name='L265'></a>    keyword whole SERVER                                   white
<a id='L266' name='L266'></a>    keyword whole ADMIN                                    white
<a id='L267' name='L267'></a>    keyword whole OWNER                                    white
<a id='L268' name='L268'></a>    keyword whole PRINCIPALS                               white
<a id='L269' name='L269'></a>    keyword whole COMPACT                                  white
<a id='L270' name='L270'></a>    keyword whole COMPACTIONS                              white
<a id='L271' name='L271'></a>    keyword whole TRANSACTIONS                             white
<a id='L272' name='L272'></a>    keyword whole REWRITE                                  white
<a id='L273' name='L273'></a>    keyword whole AUTHORIZATION                            white
<a id='L274' name='L274'></a>    keyword whole CONF                                     white
<a id='L275' name='L275'></a>    keyword whole VALUES                                   white
<a id='L276' name='L276'></a>    keyword whole RELOAD                                   white
<a id='L277' name='L277'></a>    keyword whole YEAR                                     white
<a id='L278' name='L278'></a>    keyword whole YEARS                                    white
<a id='L279' name='L279'></a>    keyword whole QUARTER                                  white
<a id='L280' name='L280'></a>    keyword whole MONTH                                    white
<a id='L281' name='L281'></a>    keyword whole MONTHS                                   white
<a id='L282' name='L282'></a>    keyword whole WEEK                                     white
<a id='L283' name='L283'></a>    keyword whole WEEKS                                    white
<a id='L284' name='L284'></a>    keyword whole DAY                                      white
<a id='L285' name='L285'></a>    keyword whole DAYS                                     white
<a id='L286' name='L286'></a>    keyword whole DAYOFWEEK                                white
<a id='L287' name='L287'></a>    keyword whole HOUR                                     white
<a id='L288' name='L288'></a>    keyword whole HOURS                                    white
<a id='L289' name='L289'></a>    keyword whole MINUTE                                   white
<a id='L290' name='L290'></a>    keyword whole MINUTES                                  white
<a id='L291' name='L291'></a>    keyword whole SECOND                                   white
<a id='L292' name='L292'></a>    keyword whole SECONDS                                  white
<a id='L293' name='L293'></a>    keyword whole START                                    white
<a id='L294' name='L294'></a>    keyword whole TRANSACTION                              white
<a id='L295' name='L295'></a>    keyword whole COMMIT                                   white
<a id='L296' name='L296'></a>    keyword whole ROLLBACK                                 white
<a id='L297' name='L297'></a>    keyword whole WORK                                     white
<a id='L298' name='L298'></a>    keyword whole ONLY                                     white
<a id='L299' name='L299'></a>    keyword whole WRITE                                    white
<a id='L300' name='L300'></a>    keyword whole ISOLATION                                white
<a id='L301' name='L301'></a>    keyword whole LEVEL                                    white
<a id='L302' name='L302'></a>    keyword whole SNAPSHOT                                 white
<a id='L303' name='L303'></a>    keyword whole AUTOCOMMIT                               white
<a id='L304' name='L304'></a>    keyword whole CACHE                                    white
<a id='L305' name='L305'></a>    keyword whole PRIMARY                                  white
<a id='L306' name='L306'></a>    keyword whole FOREIGN                                  white
<a id='L307' name='L307'></a>    keyword whole REFERENCES                               white
<a id='L308' name='L308'></a>    keyword whole CONSTRAINT                               white
<a id='L309' name='L309'></a>    keyword whole VALIDATE                                 white
<a id='L310' name='L310'></a>    keyword whole NOVALIDATE                               white
<a id='L311' name='L311'></a>    keyword whole RELY                                     white
<a id='L312' name='L312'></a>    keyword whole NORELY                                   white
<a id='L313' name='L313'></a>    keyword whole UNIQUE                                   white
<a id='L314' name='L314'></a>    keyword whole KEY                                      white
<a id='L315' name='L315'></a>    keyword whole ABORT                                    white
<a id='L316' name='L316'></a>    keyword whole EXTRACT                                  white
<a id='L317' name='L317'></a>    keyword whole FLOOR                                    white
<a id='L318' name='L318'></a>    keyword whole MERGE                                    white
<a id='L319' name='L319'></a>    keyword whole MATCHED                                  white
<a id='L320' name='L320'></a>    keyword whole REPL                                     white
<a id='L321' name='L321'></a>    keyword whole DUMP                                     white
<a id='L322' name='L322'></a>    keyword whole STATUS                                   white
<a id='L323' name='L323'></a>    keyword whole VECTORIZATION                            white
<a id='L324' name='L324'></a>    keyword whole SUMMARY                                  white
<a id='L325' name='L325'></a>    keyword whole OPERATOR                                 white
<a id='L326' name='L326'></a>    keyword whole EXPRESSION                               white
<a id='L327' name='L327'></a>    keyword whole DETAIL                                   white
<a id='L328' name='L328'></a>    keyword whole WAIT                                     white
<a id='L329' name='L329'></a> 
<a id='L330' name='L330'></a># Storage Formats
<a id='L331' name='L331'></a>    keyword whole TEXTFILE                                 brightblue
<a id='L332' name='L332'></a>    keyword whole ORC                                      brightblue
<a id='L333' name='L333'></a>    keyword whole SEQUENCEFILE                             brightblue
<a id='L334' name='L334'></a>    keyword whole RCFILE                                   brightblue
<a id='L335' name='L335'></a>    keyword whole PARQUET                                  brightblue
<a id='L336' name='L336'></a>    keyword whole AVRO                                     brightblue
<a id='L337' name='L337'></a> 
<a id='L338' name='L338'></a># Comments
<a id='L339' name='L339'></a>    keyword /\*                                            brown
<a id='L340' name='L340'></a>    keyword \*/                                            brown
<a id='L341' name='L341'></a>    keyword --                                             brown
<a id='L342' name='L342'></a> 
<a id='L343' name='L343'></a># Operators
<a id='L344' name='L344'></a>    keyword &gt;                                              brightcyan
<a id='L345' name='L345'></a>    keyword &lt;                                              brightcyan
<a id='L346' name='L346'></a>    keyword \+                                             brightcyan
<a id='L347' name='L347'></a>    keyword -                                              brightcyan
<a id='L348' name='L348'></a>    keyword \*                                             brightcyan
<a id='L349' name='L349'></a>    keyword /                                              brightcyan
<a id='L350' name='L350'></a>    keyword %                                              brightcyan
<a id='L351' name='L351'></a>    keyword =                                              brightcyan
<a id='L352' name='L352'></a>    keyword (                                              brightcyan
<a id='L353' name='L353'></a>    keyword )                                              brightcyan
<a id='L354' name='L354'></a>    keyword ,                                              brightcyan
<a id='L355' name='L355'></a>    keyword ;                                              brightcyan
<a id='L356' name='L356'></a>    keyword .                                              white
<a id='L357' name='L357'></a>    keyword \|                                             white
<a id='L358' name='L358'></a>    keyword !=                                             white
<a id='L359' name='L359'></a>    keyword \^                                             white
<a id='L360' name='L360'></a>    keyword \~                                             white
<a id='L361' name='L361'></a>    keyword whole DIV                                      white
<a id='L362' name='L362'></a>    keyword [                                              brightcyan
<a id='L363' name='L363'></a>    keyword ]                                              brightcyan
<a id='L364' name='L364'></a>    keyword {                                              brightcyan
<a id='L365' name='L365'></a>    keyword }                                              brightcyan
<a id='L366' name='L366'></a>    keyword :                                              white
<a id='L367' name='L367'></a>    keyword &amp;                                              white
<a id='L368' name='L368'></a>    keyword ?                                              white
<a id='L369' name='L369'></a> 
<a id='L370' name='L370'></a># Mathematical Functions
<a id='L371' name='L371'></a>    keyword whole round                                    yellow
<a id='L372' name='L372'></a>    keyword whole bround                                   yellow
<a id='L373' name='L373'></a>    keyword whole floor                                    yellow
<a id='L374' name='L374'></a>    keyword whole ceil                                     yellow
<a id='L375' name='L375'></a>    keyword whole rand                                     yellow
<a id='L376' name='L376'></a>    keyword whole exp                                      yellow
<a id='L377' name='L377'></a>    keyword whole ln                                       yellow
<a id='L378' name='L378'></a>    keyword whole log10                                    yellow
<a id='L379' name='L379'></a>    keyword whole log2                                     yellow
<a id='L380' name='L380'></a>    keyword whole log                                      yellow
<a id='L381' name='L381'></a>    keyword whole pow                                      yellow
<a id='L382' name='L382'></a>    keyword whole sqrt                                     yellow
<a id='L383' name='L383'></a>    keyword whole bin                                      yellow
<a id='L384' name='L384'></a>    keyword whole hex                                      yellow
<a id='L385' name='L385'></a>    keyword whole unhex                                    yellow
<a id='L386' name='L386'></a>    keyword whole conv                                     yellow
<a id='L387' name='L387'></a>    keyword whole abs                                      yellow
<a id='L388' name='L388'></a>    keyword whole pmod                                     yellow
<a id='L389' name='L389'></a>    keyword whole sin                                      yellow
<a id='L390' name='L390'></a>    keyword whole asin                                     yellow
<a id='L391' name='L391'></a>    keyword whole cos                                      yellow
<a id='L392' name='L392'></a>    keyword whole acos                                     yellow
<a id='L393' name='L393'></a>    keyword whole tan                                      yellow
<a id='L394' name='L394'></a>    keyword whole atan                                     yellow
<a id='L395' name='L395'></a>    keyword whole degrees                                  yellow
<a id='L396' name='L396'></a>    keyword whole radians                                  yellow
<a id='L397' name='L397'></a>    keyword whole positive                                 yellow
<a id='L398' name='L398'></a>    keyword whole negative                                 yellow
<a id='L399' name='L399'></a>    keyword whole sign                                     yellow
<a id='L400' name='L400'></a>    keyword whole e()                                      yellow
<a id='L401' name='L401'></a>    keyword whole pi()                                     yellow
<a id='L402' name='L402'></a>    keyword whole factorial                                yellow
<a id='L403' name='L403'></a>    keyword whole cbrt                                     yellow
<a id='L404' name='L404'></a>    keyword whole shiftleft                                yellow
<a id='L405' name='L405'></a>    keyword whole shiftright                               yellow
<a id='L406' name='L406'></a>    keyword whole shiftrightunsigned                       yellow
<a id='L407' name='L407'></a>    keyword whole greatest                                 yellow
<a id='L408' name='L408'></a>    keyword whole least                                    yellow
<a id='L409' name='L409'></a>    keyword whole width_bucket                             yellow
<a id='L410' name='L410'></a> 
<a id='L411' name='L411'></a># Collection Functions
<a id='L412' name='L412'></a>    keyword whole size                                     yellow
<a id='L413' name='L413'></a>    keyword whole map_keys                                 yellow
<a id='L414' name='L414'></a>    keyword whole map_values                               yellow
<a id='L415' name='L415'></a>    keyword whole array_contains                           yellow
<a id='L416' name='L416'></a>    keyword whole sort_array                               yellow
<a id='L417' name='L417'></a> 
<a id='L418' name='L418'></a># Type Conversion
<a id='L419' name='L419'></a>#   binary # keyword
<a id='L420' name='L420'></a>#   cast   # keyword
<a id='L421' name='L421'></a> 
<a id='L422' name='L422'></a># Date Functions
<a id='L423' name='L423'></a>    keyword whole from_unixtime                            yellow
<a id='L424' name='L424'></a>    keyword whole unix_timestamp                           yellow
<a id='L425' name='L425'></a>    keyword whole to_date                                  yellow
<a id='L426' name='L426'></a>    keyword whole year                                     yellow
<a id='L427' name='L427'></a>    keyword whole quarter                                  yellow
<a id='L428' name='L428'></a>    keyword whole month                                    yellow
<a id='L429' name='L429'></a>    keyword whole day                                      yellow
<a id='L430' name='L430'></a>    keyword whole hour                                     yellow
<a id='L431' name='L431'></a>    keyword whole minute                                   yellow
<a id='L432' name='L432'></a>    keyword whole second                                   yellow
<a id='L433' name='L433'></a>    keyword whole weekofyear                               yellow
<a id='L434' name='L434'></a>    keyword whole extract                                  yellow
<a id='L435' name='L435'></a>    keyword whole datediff                                 yellow
<a id='L436' name='L436'></a>    keyword whole date_add                                 yellow
<a id='L437' name='L437'></a>    keyword whole date_sub                                 yellow
<a id='L438' name='L438'></a>    keyword whole from_utc_timestamp                       yellow
<a id='L439' name='L439'></a>    keyword whole to_utc_timestamp                         yellow
<a id='L440' name='L440'></a>    keyword whole current_date                             yellow
<a id='L441' name='L441'></a>    keyword whole add_months                               yellow
<a id='L442' name='L442'></a>    keyword whole last_day                                 yellow
<a id='L443' name='L443'></a>    keyword whole next_day                                 yellow
<a id='L444' name='L444'></a>    keyword whole trunc                                    yellow
<a id='L445' name='L445'></a>    keyword whole months_between                           yellow
<a id='L446' name='L446'></a>    keyword whole date_format                              yellow
<a id='L447' name='L447'></a> 
<a id='L448' name='L448'></a># Conditional Functions
<a id='L449' name='L449'></a>    keyword whole if                                       yellow
<a id='L450' name='L450'></a>    keyword whole isnull                                   yellow
<a id='L451' name='L451'></a>    keyword whole isnotnull                                yellow
<a id='L452' name='L452'></a>    keyword whole coalesce                                 yellow
<a id='L453' name='L453'></a>    keyword whole nullif                                   yellow
<a id='L454' name='L454'></a>    keyword whole assert_true                              yellow
<a id='L455' name='L455'></a> 
<a id='L456' name='L456'></a># String Functions
<a id='L457' name='L457'></a>    keyword whole ascii                                    yellow
<a id='L458' name='L458'></a>    keyword whole base64                                   yellow
<a id='L459' name='L459'></a>    keyword whole character_length                         yellow
<a id='L460' name='L460'></a>    keyword whole chr                                      yellow
<a id='L461' name='L461'></a>    keyword whole concat                                   yellow
<a id='L462' name='L462'></a>    keyword whole context_ngrams                           yellow
<a id='L463' name='L463'></a>    keyword whole concat_ws                                yellow
<a id='L464' name='L464'></a>    keyword whole decode                                   yellow
<a id='L465' name='L465'></a>    keyword whole elt                                      yellow
<a id='L466' name='L466'></a>    keyword whole encode                                   yellow
<a id='L467' name='L467'></a>    keyword whole field                                    yellow
<a id='L468' name='L468'></a>    keyword whole find_in_set                              yellow
<a id='L469' name='L469'></a>    keyword whole format_number                            yellow
<a id='L470' name='L470'></a>    keyword whole get_json_object                          yellow
<a id='L471' name='L471'></a>    keyword whole in_file                                  yellow
<a id='L472' name='L472'></a>    keyword whole instr                                    yellow
<a id='L473' name='L473'></a>    keyword whole length                                   yellow
<a id='L474' name='L474'></a>    keyword whole locate                                   yellow
<a id='L475' name='L475'></a>    keyword whole lower                                    yellow
<a id='L476' name='L476'></a>    keyword whole lpad                                     yellow
<a id='L477' name='L477'></a>    keyword whole ltrim                                    yellow
<a id='L478' name='L478'></a>    keyword whole ngrams                                   yellow
<a id='L479' name='L479'></a>    keyword whole octet_length                             yellow
<a id='L480' name='L480'></a>    keyword whole parse_url                                yellow
<a id='L481' name='L481'></a>    keyword whole printf                                   yellow
<a id='L482' name='L482'></a>    keyword whole regexp_extract                           yellow
<a id='L483' name='L483'></a>    keyword whole regexp_replace                           yellow
<a id='L484' name='L484'></a>    keyword whole repeat                                   yellow
<a id='L485' name='L485'></a>    keyword whole replace                                  yellow
<a id='L486' name='L486'></a>    keyword whole reverse                                  yellow
<a id='L487' name='L487'></a>    keyword whole rpad                                     yellow
<a id='L488' name='L488'></a>    keyword whole rtrim                                    yellow
<a id='L489' name='L489'></a>    keyword whole sentences                                yellow
<a id='L490' name='L490'></a>    keyword whole space                                    yellow
<a id='L491' name='L491'></a>    keyword whole split                                    yellow
<a id='L492' name='L492'></a>    keyword whole str_to_map                               yellow
<a id='L493' name='L493'></a>    keyword whole substr                                   yellow
<a id='L494' name='L494'></a>    keyword whole substr_index                             yellow
<a id='L495' name='L495'></a>    keyword whole translate                                yellow
<a id='L496' name='L496'></a>    keyword whole trim                                     yellow
<a id='L497' name='L497'></a>    keyword whole unbase64                                 yellow
<a id='L498' name='L498'></a>    keyword whole upper                                    yellow
<a id='L499' name='L499'></a>    keyword whole initcap                                  yellow
<a id='L500' name='L500'></a>    keyword whole levenshtein                              yellow
<a id='L501' name='L501'></a>    keyword whole soundex                                  yellow
<a id='L502' name='L502'></a> 
<a id='L503' name='L503'></a># Data Masking Functions
<a id='L504' name='L504'></a>    keyword whole mask                                     yellow
<a id='L505' name='L505'></a>    keyword whole mask_first_n                             yellow
<a id='L506' name='L506'></a>    keyword whole mask_last_n                              yellow
<a id='L507' name='L507'></a>    keyword whole mask_show_first_n                        yellow
<a id='L508' name='L508'></a>    keyword whole mask_show_last_n                         yellow
<a id='L509' name='L509'></a>    keyword whole mask_hash                                yellow
<a id='L510' name='L510'></a> 
<a id='L511' name='L511'></a># Misc. Functions
<a id='L512' name='L512'></a>    keyword whole java_method                              yellow
<a id='L513' name='L513'></a>    keyword whole reflect                                  yellow
<a id='L514' name='L514'></a>    keyword whole hash                                     yellow
<a id='L515' name='L515'></a>    keyword whole current_user                             yellow
<a id='L516' name='L516'></a>    keyword whole logged_user                              yellow
<a id='L517' name='L517'></a>    keyword whole md5                                      yellow
<a id='L518' name='L518'></a>    keyword whole sha1                                     yellow
<a id='L519' name='L519'></a>    keyword whole sha                                      yellow
<a id='L520' name='L520'></a>    keyword whole crc32                                    yellow
<a id='L521' name='L521'></a>    keyword whole sha2                                     yellow
<a id='L522' name='L522'></a>    keyword whole aes_encrypt                              yellow
<a id='L523' name='L523'></a>    keyword whole aes_decrypt                              yellow
<a id='L524' name='L524'></a>    keyword whole version                                  yellow
<a id='L525' name='L525'></a> 
<a id='L526' name='L526'></a># xpath
<a id='L527' name='L527'></a>    keyword whole xpath                                    yellow
<a id='L528' name='L528'></a>    keyword whole xpath_short                              yellow
<a id='L529' name='L529'></a>    keyword whole xpath_int                                yellow
<a id='L530' name='L530'></a>    keyword whole xpath_long                               yellow
<a id='L531' name='L531'></a>    keyword whole xpath_float                              yellow
<a id='L532' name='L532'></a>    keyword whole xpath_double                             yellow
<a id='L533' name='L533'></a>    keyword whole xpath_number                             yellow
<a id='L534' name='L534'></a>    keyword whole xpath_string                             yellow
<a id='L535' name='L535'></a> 
<a id='L536' name='L536'></a># Aggregate Functions
<a id='L537' name='L537'></a>    keyword whole count                                    yellow
<a id='L538' name='L538'></a>    keyword whole sum                                      yellow
<a id='L539' name='L539'></a>    keyword whole avg                                      yellow
<a id='L540' name='L540'></a>    keyword whole min                                      yellow
<a id='L541' name='L541'></a>    keyword whole max                                      yellow
<a id='L542' name='L542'></a>    keyword whole variance                                 yellow
<a id='L543' name='L543'></a>    keyword whole var_samp                                 yellow
<a id='L544' name='L544'></a>    keyword whole stddev_pop                               yellow
<a id='L545' name='L545'></a>    keyword whole stddev_samp                              yellow
<a id='L546' name='L546'></a>    keyword whole covar_pop                                yellow
<a id='L547' name='L547'></a>    keyword whole covar_samp                               yellow
<a id='L548' name='L548'></a>    keyword whole corr                                     yellow
<a id='L549' name='L549'></a>    keyword whole percentile                               yellow
<a id='L550' name='L550'></a>    keyword whole regr_avgx                                yellow
<a id='L551' name='L551'></a>    keyword whole regr_avgy                                yellow
<a id='L552' name='L552'></a>    keyword whole regr_count                               yellow
<a id='L553' name='L553'></a>    keyword whole regr_intercept                           yellow
<a id='L554' name='L554'></a>    keyword whole regr_r2                                  yellow
<a id='L555' name='L555'></a>    keyword whole regr_slope                               yellow
<a id='L556' name='L556'></a>    keyword whole regr_sxx                                 yellow
<a id='L557' name='L557'></a>    keyword whole regr_sxy                                 yellow
<a id='L558' name='L558'></a>    keyword whole regr_syy                                 yellow
<a id='L559' name='L559'></a>    keyword whole histogram_numeric                        yellow
<a id='L560' name='L560'></a>    keyword whole collect_set                              yellow
<a id='L561' name='L561'></a>    keyword whole collect_list                             yellow
<a id='L562' name='L562'></a>    keyword whole ntile                                    yellow
<a id='L563' name='L563'></a> 
<a id='L564' name='L564'></a># Table-Generating Functions
<a id='L565' name='L565'></a>    keyword whole explode                                  yellow
<a id='L566' name='L566'></a>    keyword whole posexplode                               yellow
<a id='L567' name='L567'></a>    keyword whole inline                                   yellow
<a id='L568' name='L568'></a>    keyword whole stack                                    yellow
<a id='L569' name='L569'></a>    keyword whole json_tuple                               yellow
<a id='L570' name='L570'></a>    keyword whole parse_url                                yellow
<a id='L571' name='L571'></a> 
<a id='L572' name='L572'></a># Window Functions
<a id='L573' name='L573'></a>    keyword whole lead                                     yellow
<a id='L574' name='L574'></a>    keyword whole lag                                      yellow
<a id='L575' name='L575'></a>    keyword whole first_value                              yellow
<a id='L576' name='L576'></a>    keyword whole last_value                               yellow
<a id='L577' name='L577'></a>    keyword whole rank                                     yellow
<a id='L578' name='L578'></a>    keyword whole row_number                               yellow
<a id='L579' name='L579'></a>    keyword whole dense_rank                               yellow
<a id='L580' name='L580'></a>    keyword whole cume_dist                                yellow
<a id='L581' name='L581'></a>    keyword whole percent_rank                             yellow
<a id='L582' name='L582'></a>    keyword whole ntile                                    yellow
<a id='L583' name='L583'></a> 
<a id='L584' name='L584'></a># Variables
<a id='L585' name='L585'></a>    # oozie variables
<a id='L586' name='L586'></a>    keyword whole ${+}                                     brightgreen
<a id='L587' name='L587'></a>    # hive variables
<a id='L588' name='L588'></a>    keyword whole ${hiveconf:+}                            magenta
<a id='L589' name='L589'></a> 
<a id='L590' name='L590'></a> 
<a id='L591' name='L591'></a># Hive options
<a id='L592' name='L592'></a>    keyword wholeright hive.+.+.+                          red
<a id='L593' name='L593'></a>    keyword wholeright tez.+.+                             red
<a id='L594' name='L594'></a>    keyword wholeright mapreduce.+.+                       red
<a id='L595' name='L595'></a> 
<a id='L596' name='L596'></a># Literals
<a id='L597' name='L597'></a>    # float
<a id='L598' name='L598'></a>    keyword whole \[0123456789\]\{.\}\[0123456789\]                                           brightmagenta
<a id='L599' name='L599'></a>    # float e notation
<a id='L600' name='L600'></a>    keyword whole \[0123456789\]\[.\]\[0123456789\]\{e\}\[\+-\]\{0123456789\}\[0123456789\]   brightmagenta
<a id='L601' name='L601'></a> 
<a id='L602' name='L602'></a>    # tinyint
<a id='L603' name='L603'></a>    keyword whole \{0123456789\}\[0123456789\]Y                magenta
<a id='L604' name='L604'></a>    # smallint
<a id='L605' name='L605'></a>    keyword whole \{0123456789\}\[0123456789\]S                magenta
<a id='L606' name='L606'></a>    # bigint
<a id='L607' name='L607'></a>    keyword whole \{0123456789\}\[0123456789\]L                magenta
<a id='L608' name='L608'></a>    # int
<a id='L609' name='L609'></a>    keyword whole \{0123456789\}\[0123456789\]                 brightmagenta
<a id='L610' name='L610'></a>    # big decimal
<a id='L611' name='L611'></a>    keyword whole \{0123456789\}\[0123456789\]BD               magenta
<a id='L612' name='L612'></a> 
<a id='L613' name='L613'></a>context exclusive -- \n brown
<a id='L614' name='L614'></a>    spellcheck
<a id='L615' name='L615'></a> 
<a id='L616' name='L616'></a>context exclusive /\* \*/ brown
<a id='L617' name='L617'></a>    spellcheck
<a id='L618' name='L618'></a> 
<a id='L619' name='L619'></a>context ' ' green
<a id='L620' name='L620'></a>    keyword \\' brightgreen
<a id='L621' name='L621'></a>    # oozie variables
<a id='L622' name='L622'></a>    keyword whole ${+}                                         brightgreen
<a id='L623' name='L623'></a>    # hive variables
<a id='L624' name='L624'></a>    keyword whole ${hiveconf:+}                                magenta
<a id='L625' name='L625'></a> 
<a id='L626' name='L626'></a>context " " red
<a id='L627' name='L627'></a>    keyword \\" brightred
</pre>
<hr />
<a id='BOTTOM' name='BOTTOM'></a>
<em class='comment'>/* <img class='icon' src='../icons/n_left.png' alt='[previous]' /><img class='icon' src='../icons/n_right.png' alt='[next]' /><img class='icon' src='../icons/n_first.png' alt='[first]' /><img class='icon' src='../icons/n_last.png' alt='[last]' /><a href='#TOP'><img class='icon' src='../icons/top.png' alt='[top]' /></a><img class='icon' src='../icons/n_bottom.png' alt='[bottom]' /><a href='../mains.html'><img class='icon' src='../icons/index.png' alt='[index]' /></a><a href='../help.html'><img class='icon' src='../icons/help.png' alt='[help]' /></a>&nbsp;<input type='text' readonly onfocus='this.select();' value='+627 misc/syntax/hive.syntax'  /> */</em>
</body>
</html>
